<%@ page import="com.dx.util.JdbcUtil" %>
<%@ page import="java.sql.ResultSet" %><%--
  Created by IntelliJ IDEA.
  User: Admin
  Date: 2024/1/12
  Time: 8:58
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>Title</title>
</head>
<body>
欢迎：
<hr/>
<table>
    <th>ID</th>
    <th>姓名</th>
    <th>URL</th>
    <th>图标</th>
    <th>角色</th>
    <th>类型</th>
    <th>pid</th>
    <th>说明</th>
    <%
        String sql="SELECT t.*\n" +
        "        FROM db_cms.menu t";
        JdbcUtil util=new JdbcUtil();
        ResultSet rs=util.executeQuery(sql,null);
        if (rs!=null){
            while(rs.next()){
    %>
    <tr>
        <td><%=rs.getInt("id")%></td>
        <td><%=rs.getString("name")%></td>
        <td><%=rs.getString("url")%></td>
        <td><%=rs.getString("icon")%></td>
        <td><%=rs.getString("module_name")%></td>
        <td><%=rs.getString("type")%></td>
        <td><%=rs.getInt("pid")%></td>
        <td><%=rs.getString("description")%></td>
    </tr>
    <%
            }
        }
        util.release();
    %>
</table>
</body>
</html>
</body>
</html>
